package com.isoft.systemprovidor.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.isoft.systemprovidor.entity.PhoneBook;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface PhoneBookDao extends BaseMapper<PhoneBook> {


    /*批量导入电话簿信息*/
    @Insert("INSERT INTO TMIM_SYSTEM.TB_PHONEBOOK (SYSUSERID,USERNAME,DEPARTMENT,JOB,HOUSENUM,PHONE,LANDLINE,OFFICE,EMAIL) VALUES (#{sysuserid},#{username},#{department},#{job},#{housenum},#{phone},#{landline},#{office},#{email})")
    public int importPhoneBook (PhoneBook phoneBook);
}
